Midpoint Deliverable
Snehal S, Bernard L, Valerie T, Sasha G, Lewis.
11/14/2019
Introduction
Summary Information
The NYC dataset has over 48895 observations recording over 16 features for each house that hosted Airbnb guests in 2019. Among the features are room type, price, host name, and so on. According to the dataset, 22326 private rooms, 25409 Entire homes/apts, and 1160 shared rooms were hosted in 2019. The most expensive of them being 10000 and the least expensive being 0. Note that some airbnb housese can claim to have zero dollars in price per night because they don’t charge per night, rather by week or month. The most popular neighbourhood is Williamsburg, while the most popular neighbourhood group is Manhattan. Lastly, the sum of all reviews posted to Airbnb in 2019 is 1138005.
Summary Table
This table investigates and compares how the average Airbnb listing information such as price, number of minimum nights required, and room availability out of 365 days compares between different NYC neighborhoods. In order to make this comparison, the listing was grouped by neighborhoods.
| Neighborhood Area | Average Price for a Room ($ USD) | Average Minimum of Nights Required for a Room | Average Room Availability out of 365 Days (Days) |
|---|---|---|---|
| Bronx | 87.50 | 4.6 | 165.8 |
| Brooklyn | 124.38 | 6.1 | 100.2 |
| Manhattan | 196.88 | 8.6 | 112.0 |
| Queens | 99.52 | 5.2 | 144.5 |
| Staten Island | 114.81 | 4.8 | 199.7 |
Interpretations & Insights:
- The highest average price for a room is in Manhattan for a whopping $196.88 while the lowest is in Bronx for $87.50.
- The largest average minimum of nights required for a room is in Manhattan with 8.6 days while the lowest is in Bronx with 4.6 days.
- The average room availability out of 365 days is the highest in Staten Island with 199.7 days while the lowest is in Brooklyn with 100.2 dats.
Charts
Bar Chart
Purpose: This chart was meant to visually inform the viewer of how the number of Airbnb listings vary per neighborhood. Using a bar chart can help allow the viewer to easily contrast the different number of listings between neighborhoods.
Insights:
- The neighborhood group with the most number of Airbnb listings is Manhattan with about 22,500~ listings. Brooklyn comes in close for 2nd with about 20,000~ listings.
- The neighborhood group with the least number of Airbnb listings is Staten Island with about 1,000~ listings.
Chart Map
Purpose: This chart was intended to show the distribution of Airbnb-hosted houses in New York City to expand the user’s perspective of which neighbourhoods seem to dominate the real estate market (in terms of temperoray renting).
Insights:
- It appears that houses closer to a coast or near central NY appear to dominate the map. Perhaps because people are attracted to the view.
- The popup labels reveal that house prices in densely populated Airbnb markets, on average, are much higher compared to regions with fewer Airbnb houses for guests.
Donut Pie Chart
Purpose: This chart is intended to show the portion of types of different rooms on Airbnb in New York City. A pie chart is very useful in this situation because it gives people a intuative way to understand the proportion of different room types.
Insights:
- The number of entire home/apt is almost the same as private room.
- And the proportion of shared rooms is very small. It might be a result that most people go to New York City wish to live in a private space.